package office.dao.hr;

import platform.common.dao.impl.BaseDomainProviderImpl;

public class RecruitRequirementDP extends BaseDomainProviderImpl{
	
	/**
	 * 获取某部门的招聘需求
	 * @return
	 */
	public String getFindByDept(){
		return "select new office.action.hr.wrapper.RecruitRequirementWrapper" +
				"(a.id,a.station,a.equirementdate,a.population,a.remak,a.stationRequire," +
				"a.deptId,b.name) from "+this.getDomainClassName()+" a,office.bo.system.Department b " +
				"where a.deptId=:deptId and a.deptId = b.id order by a.station";
	}
	
	/**
	 * 获取所有的招聘需求
	 * @return
	 */
	public String getFindAll(){
		return "select new office.action.hr.wrapper.RecruitRequirementWrapper" +
				"(a.id,a.station,a.equirementdate,a.population,a.remak,a.stationRequire," +
				"a.deptId,b.name) from "+this.getDomainClassName()+" a,office.bo.system.Department b " +
				"where a.deptId = b.id order by a.station";
	}
	
}
